package com.the4man.framework.model.gen;

import java.util.ArrayList;
import java.util.List;

/**
 * Created by lenovo on 2017/12/11.
 */
public class RoomExampleBase {
    protected String orderByClause;
    protected boolean distinct;
    protected List<Criteria> oredCriteria = new ArrayList();
    protected int limitStart = -1;
    protected int rowsPerPage = -1;

    public RoomExampleBase() {
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return this.orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return this.distinct;
    }

    public List<RoomExampleBase.Criteria> getOredCriteria() {
        return this.oredCriteria;
    }

    public void or(RoomExampleBase.Criteria criteria) {
        this.oredCriteria.add(criteria);
    }

    public RoomExampleBase.Criteria or() {
        RoomExampleBase.Criteria criteria = this.createCriteriaInternal();
        this.oredCriteria.add(criteria);
        return criteria;
    }

    public RoomExampleBase.Criteria createCriteria() {
        RoomExampleBase.Criteria criteria = this.createCriteriaInternal();
        if(this.oredCriteria.size() == 0) {
            this.oredCriteria.add(criteria);
        }

        return criteria;
    }

    protected RoomExampleBase.Criteria createCriteriaInternal() {
        RoomExampleBase.Criteria criteria = new RoomExampleBase.Criteria();
        return criteria;
    }

    public void clear() {
        this.oredCriteria.clear();
        this.orderByClause = null;
        this.distinct = false;
    }

    public void setLimitStart(int limitStart) {
        this.limitStart = limitStart;
    }

    public int getLimitStart() {
        return this.limitStart;
    }

    public void setRowsPerPage(int rowsPerPage) {
        this.rowsPerPage = rowsPerPage;
    }

    public int getRowsPerPage() {
        return this.rowsPerPage;
    }

    public static class Criteria extends RoomExampleBase.GeneratedCriteria {
        protected Criteria() {
        }
    }

    public static class Criterion {
        private String condition;
        private Object value;
        private Object secondValue;
        private boolean noValue;
        private boolean singleValue;
        private boolean betweenValue;
        private boolean listValue;
        private String typeHandler;

        public String getCondition() {
            return this.condition;
        }

        public Object getValue() {
            return this.value;
        }

        public Object getSecondValue() {
            return this.secondValue;
        }

        public boolean isNoValue() {
            return this.noValue;
        }

        public boolean isSingleValue() {
            return this.singleValue;
        }

        public boolean isBetweenValue() {
            return this.betweenValue;
        }

        public boolean isListValue() {
            return this.listValue;
        }

        public String getTypeHandler() {
            return this.typeHandler;
        }

        protected Criterion(String condition) {
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if(value instanceof List) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }

        }

        protected Criterion(String condition, Object value) {
            this(condition, value, (String)null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, (String)null);
        }
    }

    protected abstract static class GeneratedCriteria {
        protected List<RoomExampleBase.Criterion> criteria = new ArrayList();

        protected GeneratedCriteria() {
        }

        public boolean isValid() {
            return this.criteria.size() > 0;
        }

        public List<RoomExampleBase.Criterion> getAllCriteria() {
            return this.criteria;
        }

        public List<RoomExampleBase.Criterion> getCriteria() {
            return this.criteria;
        }

        protected void addCriterion(String condition) {
            if(condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            } else {
                this.criteria.add(new RoomExampleBase.Criterion(condition));
            }
        }

        protected void addCriterion(String condition, Object value, String property) {
            if(value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            } else {
                this.criteria.add(new RoomExampleBase.Criterion(condition, value));
            }
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if(value1 != null && value2 != null) {
                this.criteria.add(new RoomExampleBase.Criterion(condition, value1, value2));
            } else {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
        }

        public RoomExampleBase.Criteria andIdIsNull() {
            this.addCriterion("id is null");
            return (RoomExampleBase.Criteria)this;
        }

        public RoomExampleBase.Criteria andIdIsNotNull() {
            this.addCriterion("id is not null");
            return (RoomExampleBase.Criteria)this;
        }

        public RoomExampleBase.Criteria andIdEqualTo(String value) {
            this.addCriterion("id =", value, "id");
            return (RoomExampleBase.Criteria)this;
        }

        public RoomExampleBase.Criteria andIdNotEqualTo(String value) {
            this.addCriterion("id <>", value, "id");
            return (RoomExampleBase.Criteria)this;
        }

        public RoomExampleBase.Criteria andIdGreaterThan(String value) {
            this.addCriterion("id >", value, "id");
            return (RoomExampleBase.Criteria)this;
        }

        public RoomExampleBase.Criteria andIdGreaterThanOrEqualTo(String value) {
            this.addCriterion("id >=", value, "id");
            return (RoomExampleBase.Criteria)this;
        }

        public RoomExampleBase.Criteria andIdLessThan(String value) {
            this.addCriterion("id <", value, "id");
            return (RoomExampleBase.Criteria)this;
        }

        public RoomExampleBase.Criteria andIdLessThanOrEqualTo(String value) {
            this.addCriterion("id <=", value, "id");
            return (RoomExampleBase.Criteria)this;
        }

        public RoomExampleBase.Criteria andIdLike(String value) {
            this.addCriterion("id like", value, "id");
            return (RoomExampleBase.Criteria)this;
        }

        public RoomExampleBase.Criteria andIdNotLike(String value) {
            this.addCriterion("id not like", value, "id");
            return (RoomExampleBase.Criteria)this;
        }

        public RoomExampleBase.Criteria andIdIn(List<String> values) {
            this.addCriterion("id in", values, "id");
            return (RoomExampleBase.Criteria)this;
        }

        public RoomExampleBase.Criteria andIdNotIn(List<String> values) {
            this.addCriterion("id not in", values, "id");
            return (RoomExampleBase.Criteria)this;
        }

        public RoomExampleBase.Criteria andIdBetween(String value1, String value2) {
            this.addCriterion("id between", value1, value2, "id");
            return (RoomExampleBase.Criteria)this;
        }

        public RoomExampleBase.Criteria andIdNotBetween(String value1, String value2) {
            this.addCriterion("id not between", value1, value2, "id");
            return (RoomExampleBase.Criteria)this;
        }

        public RoomExampleBase.Criteria andRoomNoIsNull() {
            this.addCriterion("room_no is null");
            return (RoomExampleBase.Criteria)this;
        }

        public RoomExampleBase.Criteria andRoomNoIsNotNull() {
            this.addCriterion("room_no is not null");
            return (RoomExampleBase.Criteria)this;
        }

        public RoomExampleBase.Criteria andRoomNoEqualTo(String value) {
            this.addCriterion("room_no =", value, "roomNo");
            return (RoomExampleBase.Criteria)this;
        }

        public RoomExampleBase.Criteria andRoomNoNotEqualTo(String value) {
            this.addCriterion("room_no <>", value, "roomNo");
            return (RoomExampleBase.Criteria)this;
        }

        public RoomExampleBase.Criteria andRoomNoGreaterThan(String value) {
            this.addCriterion("room_no >", value, "roomNo");
            return (RoomExampleBase.Criteria)this;
        }

        public RoomExampleBase.Criteria andRoomNoGreaterThanOrEqualTo(String value) {
            this.addCriterion("room_no >=", value, "roomNo");
            return (RoomExampleBase.Criteria)this;
        }

        public RoomExampleBase.Criteria andRoomNoLessThan(String value) {
            this.addCriterion("room_no <", value, "roomNo");
            return (RoomExampleBase.Criteria)this;
        }

        public RoomExampleBase.Criteria andRoomNoLessThanOrEqualTo(String value) {
            this.addCriterion("room_no <=", value, "roomNo");
            return (RoomExampleBase.Criteria)this;
        }

        public RoomExampleBase.Criteria andRoomNoLike(String value) {
            this.addCriterion("room_no like", value, "roomNo");
            return (RoomExampleBase.Criteria)this;
        }

        public RoomExampleBase.Criteria andRoomNoNotLike(String value) {
            this.addCriterion("room_no not like", value, "roomNo");
            return (RoomExampleBase.Criteria)this;
        }

        public RoomExampleBase.Criteria andRoomNoIn(List<String> values) {
            this.addCriterion("room_no in", values, "roomNo");
            return (RoomExampleBase.Criteria)this;
        }

        public RoomExampleBase.Criteria andRoomNoNotIn(List<String> values) {
            this.addCriterion("room_no not in", values, "roomNo");
            return (RoomExampleBase.Criteria)this;
        }

        public RoomExampleBase.Criteria andRoomNoBetween(String value1, String value2) {
            this.addCriterion("room_no between", value1, value2, "roomNo");
            return (RoomExampleBase.Criteria)this;
        }

        public RoomExampleBase.Criteria andRoomNoNotBetween(String value1, String value2) {
            this.addCriterion("room_no not between", value1, value2, "roomNo");
            return (RoomExampleBase.Criteria)this;
        }

        public RoomExampleBase.Criteria andTypeIsNull() {
            this.addCriterion("type is null");
            return (RoomExampleBase.Criteria)this;
        }

        public RoomExampleBase.Criteria andTypeIsNotNull() {
            this.addCriterion("type is not null");
            return (RoomExampleBase.Criteria)this;
        }

        public RoomExampleBase.Criteria andTypeEqualTo(String value) {
            this.addCriterion("type =", value, "type");
            return (RoomExampleBase.Criteria)this;
        }

        public RoomExampleBase.Criteria andTypeNotEqualTo(String value) {
            this.addCriterion("type <>", value, "type");
            return (RoomExampleBase.Criteria)this;
        }

        public RoomExampleBase.Criteria andTypeGreaterThan(String value) {
            this.addCriterion("type >", value, "type");
            return (RoomExampleBase.Criteria)this;
        }

        public RoomExampleBase.Criteria andTypeGreaterThanOrEqualTo(String value) {
            this.addCriterion("type >=", value, "type");
            return (RoomExampleBase.Criteria)this;
        }

        public RoomExampleBase.Criteria andTypeLessThan(String value) {
            this.addCriterion("type <", value, "type");
            return (RoomExampleBase.Criteria)this;
        }

        public RoomExampleBase.Criteria andTypeLessThanOrEqualTo(String value) {
            this.addCriterion("type <=", value, "type");
            return (RoomExampleBase.Criteria)this;
        }

        public RoomExampleBase.Criteria andTypeLike(String value) {
            this.addCriterion("type like", value, "type");
            return (RoomExampleBase.Criteria)this;
        }

        public RoomExampleBase.Criteria andTypeNotLike(String value) {
            this.addCriterion("type not like", value, "type");
            return (RoomExampleBase.Criteria)this;
        }

        public RoomExampleBase.Criteria andTypeIn(List<String> values) {
            this.addCriterion("type in", values, "type");
            return (RoomExampleBase.Criteria)this;
        }

        public RoomExampleBase.Criteria andTypeNotIn(List<String> values) {
            this.addCriterion("type not in", values, "type");
            return (RoomExampleBase.Criteria)this;
        }

        public RoomExampleBase.Criteria andTypeBetween(String value1, String value2) {
            this.addCriterion("type between", value1, value2, "type");
            return (RoomExampleBase.Criteria)this;
        }

        public RoomExampleBase.Criteria andTypeNotBetween(String value1, String value2) {
            this.addCriterion("type not between", value1, value2, "type");
            return (RoomExampleBase.Criteria)this;
        }

        public RoomExampleBase.Criteria andPropsIsNull() {
            this.addCriterion("props is null");
            return (RoomExampleBase.Criteria)this;
        }

        public RoomExampleBase.Criteria andPropsIsNotNull() {
            this.addCriterion("props is not null");
            return (RoomExampleBase.Criteria)this;
        }

        public RoomExampleBase.Criteria andPropsEqualTo(String value) {
            this.addCriterion("props =", value, "props");
            return (RoomExampleBase.Criteria)this;
        }

        public RoomExampleBase.Criteria andPropsNotEqualTo(String value) {
            this.addCriterion("props <>", value, "props");
            return (RoomExampleBase.Criteria)this;
        }

        public RoomExampleBase.Criteria andPropsGreaterThan(String value) {
            this.addCriterion("props >", value, "props");
            return (RoomExampleBase.Criteria)this;
        }

        public RoomExampleBase.Criteria andPropsGreaterThanOrEqualTo(String value) {
            this.addCriterion("props >=", value, "props");
            return (RoomExampleBase.Criteria)this;
        }

        public RoomExampleBase.Criteria andPropsLessThan(String value) {
            this.addCriterion("props <", value, "props");
            return (RoomExampleBase.Criteria)this;
        }

        public RoomExampleBase.Criteria andPropsLessThanOrEqualTo(String value) {
            this.addCriterion("props <=", value, "props");
            return (RoomExampleBase.Criteria)this;
        }

        public RoomExampleBase.Criteria andPropsLike(String value) {
            this.addCriterion("props like", value, "props");
            return (RoomExampleBase.Criteria)this;
        }

        public RoomExampleBase.Criteria andPropsNotLike(String value) {
            this.addCriterion("props not like", value, "props");
            return (RoomExampleBase.Criteria)this;
        }

        public RoomExampleBase.Criteria andPropsIn(List<String> values) {
            this.addCriterion("props in", values, "props");
            return (RoomExampleBase.Criteria)this;
        }

        public RoomExampleBase.Criteria andPropsNotIn(List<String> values) {
            this.addCriterion("props not in", values, "props");
            return (RoomExampleBase.Criteria)this;
        }

        public RoomExampleBase.Criteria andPropsBetween(String value1, String value2) {
            this.addCriterion("props between", value1, value2, "props");
            return (RoomExampleBase.Criteria)this;
        }

        public RoomExampleBase.Criteria andPropsNotBetween(String value1, String value2) {
            this.addCriterion("props not between", value1, value2, "props");
            return (RoomExampleBase.Criteria)this;
        }

        public RoomExampleBase.Criteria andDeckIsNull() {
            this.addCriterion("deck is null");
            return (RoomExampleBase.Criteria)this;
        }

        public RoomExampleBase.Criteria andDeckIsNotNull() {
            this.addCriterion("deck is not null");
            return (RoomExampleBase.Criteria)this;
        }

        public RoomExampleBase.Criteria andDeckEqualTo(String value) {
            this.addCriterion("deck =", value, "deck");
            return (RoomExampleBase.Criteria)this;
        }

        public RoomExampleBase.Criteria andDeckNotEqualTo(String value) {
            this.addCriterion("deck <>", value, "deck");
            return (RoomExampleBase.Criteria)this;
        }

        public RoomExampleBase.Criteria andDeckGreaterThan(String value) {
            this.addCriterion("deck >", value, "deck");
            return (RoomExampleBase.Criteria)this;
        }

        public RoomExampleBase.Criteria andDeckGreaterThanOrEqualTo(String value) {
            this.addCriterion("deck >=", value, "deck");
            return (RoomExampleBase.Criteria)this;
        }

        public RoomExampleBase.Criteria andDeckLessThan(String value) {
            this.addCriterion("deck <", value, "deck");
            return (RoomExampleBase.Criteria)this;
        }

        public RoomExampleBase.Criteria andDeckLessThanOrEqualTo(String value) {
            this.addCriterion("deck <=", value, "deck");
            return (RoomExampleBase.Criteria)this;
        }

        public RoomExampleBase.Criteria andDeckLike(String value) {
            this.addCriterion("deck like", value, "deck");
            return (RoomExampleBase.Criteria)this;
        }

        public RoomExampleBase.Criteria andDeckNotLike(String value) {
            this.addCriterion("deck not like", value, "deck");
            return (RoomExampleBase.Criteria)this;
        }

        public RoomExampleBase.Criteria andDeckIn(List<String> values) {
            this.addCriterion("deck in", values, "deck");
            return (RoomExampleBase.Criteria)this;
        }

        public RoomExampleBase.Criteria andDeckNotIn(List<String> values) {
            this.addCriterion("deck not in", values, "deck");
            return (RoomExampleBase.Criteria)this;
        }

        public RoomExampleBase.Criteria andDeckBetween(String value1, String value2) {
            this.addCriterion("deck between", value1, value2, "deck");
            return (RoomExampleBase.Criteria)this;
        }

        public RoomExampleBase.Criteria andDeckNotBetween(String value1, String value2) {
            this.addCriterion("deck not between", value1, value2, "deck");
            return (RoomExampleBase.Criteria)this;
        }

        public RoomExampleBase.Criteria andAreaIsNull() {
            this.addCriterion("area is null");
            return (RoomExampleBase.Criteria)this;
        }

        public RoomExampleBase.Criteria andAreaIsNotNull() {
            this.addCriterion("area is not null");
            return (RoomExampleBase.Criteria)this;
        }

        public RoomExampleBase.Criteria andAreaEqualTo(String value) {
            this.addCriterion("area =", value, "area");
            return (RoomExampleBase.Criteria)this;
        }

        public RoomExampleBase.Criteria andAreaNotEqualTo(String value) {
            this.addCriterion("area <>", value, "area");
            return (RoomExampleBase.Criteria)this;
        }

        public RoomExampleBase.Criteria andAreaGreaterThan(String value) {
            this.addCriterion("area >", value, "area");
            return (RoomExampleBase.Criteria)this;
        }

        public RoomExampleBase.Criteria andAreaGreaterThanOrEqualTo(String value) {
            this.addCriterion("area >=", value, "area");
            return (RoomExampleBase.Criteria)this;
        }

        public RoomExampleBase.Criteria andAreaLessThan(String value) {
            this.addCriterion("area <", value, "area");
            return (RoomExampleBase.Criteria)this;
        }

        public RoomExampleBase.Criteria andAreaLessThanOrEqualTo(String value) {
            this.addCriterion("area <=", value, "area");
            return (RoomExampleBase.Criteria)this;
        }

        public RoomExampleBase.Criteria andAreaLike(String value) {
            this.addCriterion("area like", value, "area");
            return (RoomExampleBase.Criteria)this;
        }

        public RoomExampleBase.Criteria andAreaNotLike(String value) {
            this.addCriterion("area not like", value, "area");
            return (RoomExampleBase.Criteria)this;
        }

        public RoomExampleBase.Criteria andAreaIn(List<String> values) {
            this.addCriterion("area in", values, "area");
            return (RoomExampleBase.Criteria)this;
        }

        public RoomExampleBase.Criteria andAreaNotIn(List<String> values) {
            this.addCriterion("area not in", values, "area");
            return (RoomExampleBase.Criteria)this;
        }

        public RoomExampleBase.Criteria andAreaBetween(String value1, String value2) {
            this.addCriterion("area between", value1, value2, "area");
            return (RoomExampleBase.Criteria)this;
        }

        public RoomExampleBase.Criteria andAreaNotBetween(String value1, String value2) {
            this.addCriterion("area not between", value1, value2, "area");
            return (RoomExampleBase.Criteria)this;
        }

        public RoomExampleBase.Criteria andItemInfoIsNull() {
            this.addCriterion("item_info is null");
            return (RoomExampleBase.Criteria)this;
        }

        public RoomExampleBase.Criteria andItemInfoIsNotNull() {
            this.addCriterion("item_info is not null");
            return (RoomExampleBase.Criteria)this;
        }

        public RoomExampleBase.Criteria andItemInfoEqualTo(String value) {
            this.addCriterion("item_info =", value, "itemInfo");
            return (RoomExampleBase.Criteria)this;
        }

        public RoomExampleBase.Criteria andItemInfoNotEqualTo(String value) {
            this.addCriterion("item_info <>", value, "itemInfo");
            return (RoomExampleBase.Criteria)this;
        }

        public RoomExampleBase.Criteria andItemInfoGreaterThan(String value) {
            this.addCriterion("item_info >", value, "itemInfo");
            return (RoomExampleBase.Criteria)this;
        }

        public RoomExampleBase.Criteria andItemInfoGreaterThanOrEqualTo(String value) {
            this.addCriterion("item_info >=", value, "itemInfo");
            return (RoomExampleBase.Criteria)this;
        }

        public RoomExampleBase.Criteria andItemInfoLessThan(String value) {
            this.addCriterion("item_info <", value, "itemInfo");
            return (RoomExampleBase.Criteria)this;
        }

        public RoomExampleBase.Criteria andItemInfoLessThanOrEqualTo(String value) {
            this.addCriterion("item_info <=", value, "itemInfo");
            return (RoomExampleBase.Criteria)this;
        }

        public RoomExampleBase.Criteria andItemInfoLike(String value) {
            this.addCriterion("item_info like", value, "itemInfo");
            return (RoomExampleBase.Criteria)this;
        }

        public RoomExampleBase.Criteria andItemInfoNotLike(String value) {
            this.addCriterion("item_info not like", value, "itemInfo");
            return (RoomExampleBase.Criteria)this;
        }

        public RoomExampleBase.Criteria andItemInfoIn(List<String> values) {
            this.addCriterion("item_info in", values, "itemInfo");
            return (RoomExampleBase.Criteria)this;
        }

        public RoomExampleBase.Criteria andItemInfoNotIn(List<String> values) {
            this.addCriterion("item_info not in", values, "itemInfo");
            return (RoomExampleBase.Criteria)this;
        }

        public RoomExampleBase.Criteria andItemInfoBetween(String value1, String value2) {
            this.addCriterion("item_info between", value1, value2, "itemInfo");
            return (RoomExampleBase.Criteria)this;
        }

        public RoomExampleBase.Criteria andItemInfoNotBetween(String value1, String value2) {
            this.addCriterion("item_info not between", value1, value2, "itemInfo");
            return (RoomExampleBase.Criteria)this;
        }

        public RoomExampleBase.Criteria andEmployeeNumIsNull() {
            this.addCriterion("employee_num is null");
            return (RoomExampleBase.Criteria)this;
        }

        public RoomExampleBase.Criteria andEmployeeNumIsNotNull() {
            this.addCriterion("employee_num is not null");
            return (RoomExampleBase.Criteria)this;
        }

        public RoomExampleBase.Criteria andEmployeeNumEqualTo(Short value) {
            this.addCriterion("employee_num =", value, "employeeNum");
            return (RoomExampleBase.Criteria)this;
        }

        public RoomExampleBase.Criteria andEmployeeNumNotEqualTo(Short value) {
            this.addCriterion("employee_num <>", value, "employeeNum");
            return (RoomExampleBase.Criteria)this;
        }

        public RoomExampleBase.Criteria andEmployeeNumGreaterThan(Short value) {
            this.addCriterion("employee_num >", value, "employeeNum");
            return (RoomExampleBase.Criteria)this;
        }

        public RoomExampleBase.Criteria andEmployeeNumGreaterThanOrEqualTo(Short value) {
            this.addCriterion("employee_num >=", value, "employeeNum");
            return (RoomExampleBase.Criteria)this;
        }

        public RoomExampleBase.Criteria andEmployeeNumLessThan(Short value) {
            this.addCriterion("employee_num <", value, "employeeNum");
            return (RoomExampleBase.Criteria)this;
        }

        public RoomExampleBase.Criteria andEmployeeNumLessThanOrEqualTo(Short value) {
            this.addCriterion("employee_num <=", value, "employeeNum");
            return (RoomExampleBase.Criteria)this;
        }

        public RoomExampleBase.Criteria andEmployeeNumIn(List<Short> values) {
            this.addCriterion("employee_num in", values, "employeeNum");
            return (RoomExampleBase.Criteria)this;
        }

        public RoomExampleBase.Criteria andEmployeeNumNotIn(List<Short> values) {
            this.addCriterion("employee_num not in", values, "employeeNum");
            return (RoomExampleBase.Criteria)this;
        }

        public RoomExampleBase.Criteria andEmployeeNumBetween(Short value1, Short value2) {
            this.addCriterion("employee_num between", value1, value2, "employeeNum");
            return (RoomExampleBase.Criteria)this;
        }

        public RoomExampleBase.Criteria andEmployeeNumNotBetween(Short value1, Short value2) {
            this.addCriterion("employee_num not between", value1, value2, "employeeNum");
            return (RoomExampleBase.Criteria)this;
        }

        public RoomExampleBase.Criteria andBedNoIsNull() {
            this.addCriterion("bed_no is null");
            return (RoomExampleBase.Criteria)this;
        }

        public RoomExampleBase.Criteria andBedNoIsNotNull() {
            this.addCriterion("bed_no is not null");
            return (RoomExampleBase.Criteria)this;
        }

        public RoomExampleBase.Criteria andBedNoEqualTo(String value) {
            this.addCriterion("bed_no =", value, "bedNo");
            return (RoomExampleBase.Criteria)this;
        }

        public RoomExampleBase.Criteria andBedNoNotEqualTo(String value) {
            this.addCriterion("bed_no <>", value, "bedNo");
            return (RoomExampleBase.Criteria)this;
        }

        public RoomExampleBase.Criteria andBedNoGreaterThan(String value) {
            this.addCriterion("bed_no >", value, "bedNo");
            return (RoomExampleBase.Criteria)this;
        }

        public RoomExampleBase.Criteria andBedNoGreaterThanOrEqualTo(String value) {
            this.addCriterion("bed_no >=", value, "bedNo");
            return (RoomExampleBase.Criteria)this;
        }

        public RoomExampleBase.Criteria andBedNoLessThan(String value) {
            this.addCriterion("bed_no <", value, "bedNo");
            return (RoomExampleBase.Criteria)this;
        }

        public RoomExampleBase.Criteria andBedNoLessThanOrEqualTo(String value) {
            this.addCriterion("bed_no <=", value, "bedNo");
            return (RoomExampleBase.Criteria)this;
        }

        public RoomExampleBase.Criteria andBedNoLike(String value) {
            this.addCriterion("bed_no like", value, "bedNo");
            return (RoomExampleBase.Criteria)this;
        }

        public RoomExampleBase.Criteria andBedNoNotLike(String value) {
            this.addCriterion("bed_no not like", value, "bedNo");
            return (RoomExampleBase.Criteria)this;
        }

        public RoomExampleBase.Criteria andBedNoIn(List<String> values) {
            this.addCriterion("bed_no in", values, "bedNo");
            return (RoomExampleBase.Criteria)this;
        }

        public RoomExampleBase.Criteria andBedNoNotIn(List<String> values) {
            this.addCriterion("bed_no not in", values, "bedNo");
            return (RoomExampleBase.Criteria)this;
        }

        public RoomExampleBase.Criteria andBedNoBetween(String value1, String value2) {
            this.addCriterion("bed_no between", value1, value2, "bedNo");
            return (RoomExampleBase.Criteria)this;
        }

        public RoomExampleBase.Criteria andBedNoNotBetween(String value1, String value2) {
            this.addCriterion("bed_no not between", value1, value2, "bedNo");
            return (RoomExampleBase.Criteria)this;
        }

        public RoomExampleBase.Criteria andDoorNoIsNull() {
            this.addCriterion("door_no is null");
            return (RoomExampleBase.Criteria)this;
        }

        public RoomExampleBase.Criteria andDoorNoIsNotNull() {
            this.addCriterion("door_no is not null");
            return (RoomExampleBase.Criteria)this;
        }

        public RoomExampleBase.Criteria andDoorNoEqualTo(String value) {
            this.addCriterion("door_no =", value, "doorNo");
            return (RoomExampleBase.Criteria)this;
        }

        public RoomExampleBase.Criteria andDoorNoNotEqualTo(String value) {
            this.addCriterion("door_no <>", value, "doorNo");
            return (RoomExampleBase.Criteria)this;
        }

        public RoomExampleBase.Criteria andDoorNoGreaterThan(String value) {
            this.addCriterion("door_no >", value, "doorNo");
            return (RoomExampleBase.Criteria)this;
        }

        public RoomExampleBase.Criteria andDoorNoGreaterThanOrEqualTo(String value) {
            this.addCriterion("door_no >=", value, "doorNo");
            return (RoomExampleBase.Criteria)this;
        }

        public RoomExampleBase.Criteria andDoorNoLessThan(String value) {
            this.addCriterion("door_no <", value, "doorNo");
            return (RoomExampleBase.Criteria)this;
        }

        public RoomExampleBase.Criteria andDoorNoLessThanOrEqualTo(String value) {
            this.addCriterion("door_no <=", value, "doorNo");
            return (RoomExampleBase.Criteria)this;
        }

        public RoomExampleBase.Criteria andDoorNoLike(String value) {
            this.addCriterion("door_no like", value, "doorNo");
            return (RoomExampleBase.Criteria)this;
        }

        public RoomExampleBase.Criteria andDoorNoNotLike(String value) {
            this.addCriterion("door_no not like", value, "doorNo");
            return (RoomExampleBase.Criteria)this;
        }

        public RoomExampleBase.Criteria andDoorNoIn(List<String> values) {
            this.addCriterion("door_no in", values, "doorNo");
            return (RoomExampleBase.Criteria)this;
        }

        public RoomExampleBase.Criteria andDoorNoNotIn(List<String> values) {
            this.addCriterion("door_no not in", values, "doorNo");
            return (RoomExampleBase.Criteria)this;
        }

        public RoomExampleBase.Criteria andDoorNoBetween(String value1, String value2) {
            this.addCriterion("door_no between", value1, value2, "doorNo");
            return (RoomExampleBase.Criteria)this;
        }

        public RoomExampleBase.Criteria andDoorNoNotBetween(String value1, String value2) {
            this.addCriterion("door_no not between", value1, value2, "doorNo");
            return (RoomExampleBase.Criteria)this;
        }

        public RoomExampleBase.Criteria andLockedIsNull() {
            this.addCriterion("locked is null");
            return (RoomExampleBase.Criteria)this;
        }

        public RoomExampleBase.Criteria andLockedIsNotNull() {
            this.addCriterion("locked is not null");
            return (RoomExampleBase.Criteria)this;
        }

        public RoomExampleBase.Criteria andLockedEqualTo(Short value) {
            this.addCriterion("locked =", value, "locked");
            return (RoomExampleBase.Criteria)this;
        }

        public RoomExampleBase.Criteria andLockedNotEqualTo(Short value) {
            this.addCriterion("locked <>", value, "locked");
            return (RoomExampleBase.Criteria)this;
        }

        public RoomExampleBase.Criteria andLockedGreaterThan(Short value) {
            this.addCriterion("locked >", value, "locked");
            return (RoomExampleBase.Criteria)this;
        }

        public RoomExampleBase.Criteria andLockedGreaterThanOrEqualTo(Short value) {
            this.addCriterion("locked >=", value, "locked");
            return (RoomExampleBase.Criteria)this;
        }

        public RoomExampleBase.Criteria andLockedLessThan(Short value) {
            this.addCriterion("locked <", value, "locked");
            return (RoomExampleBase.Criteria)this;
        }

        public RoomExampleBase.Criteria andLockedLessThanOrEqualTo(Short value) {
            this.addCriterion("locked <=", value, "locked");
            return (RoomExampleBase.Criteria)this;
        }

        public RoomExampleBase.Criteria andLockedIn(List<Short> values) {
            this.addCriterion("locked in", values, "locked");
            return (RoomExampleBase.Criteria)this;
        }

        public RoomExampleBase.Criteria andLockedNotIn(List<Short> values) {
            this.addCriterion("locked not in", values, "locked");
            return (RoomExampleBase.Criteria)this;
        }

        public RoomExampleBase.Criteria andLockedBetween(Short value1, Short value2) {
            this.addCriterion("locked between", value1, value2, "locked");
            return (RoomExampleBase.Criteria)this;
        }

        public RoomExampleBase.Criteria andLockedNotBetween(Short value1, Short value2) {
            this.addCriterion("locked not between", value1, value2, "locked");
            return (RoomExampleBase.Criteria)this;
        }

        public RoomExampleBase.Criteria andCreateTimeIsNull() {
            this.addCriterion("create_time is null");
            return (RoomExampleBase.Criteria)this;
        }

        public RoomExampleBase.Criteria andCreateTimeIsNotNull() {
            this.addCriterion("create_time is not null");
            return (RoomExampleBase.Criteria)this;
        }

        public RoomExampleBase.Criteria andCreateTimeEqualTo(String value) {
            this.addCriterion("create_time =", value, "createTime");
            return (RoomExampleBase.Criteria)this;
        }

        public RoomExampleBase.Criteria andCreateTimeNotEqualTo(String value) {
            this.addCriterion("create_time <>", value, "createTime");
            return (RoomExampleBase.Criteria)this;
        }

        public RoomExampleBase.Criteria andCreateTimeGreaterThan(String value) {
            this.addCriterion("create_time >", value, "createTime");
            return (RoomExampleBase.Criteria)this;
        }

        public RoomExampleBase.Criteria andCreateTimeGreaterThanOrEqualTo(String value) {
            this.addCriterion("create_time >=", value, "createTime");
            return (RoomExampleBase.Criteria)this;
        }

        public RoomExampleBase.Criteria andCreateTimeLessThan(String value) {
            this.addCriterion("create_time <", value, "createTime");
            return (RoomExampleBase.Criteria)this;
        }

        public RoomExampleBase.Criteria andCreateTimeLessThanOrEqualTo(String value) {
            this.addCriterion("create_time <=", value, "createTime");
            return (RoomExampleBase.Criteria)this;
        }

        public RoomExampleBase.Criteria andCreateTimeLike(String value) {
            this.addCriterion("create_time like", value, "createTime");
            return (RoomExampleBase.Criteria)this;
        }

        public RoomExampleBase.Criteria andCreateTimeNotLike(String value) {
            this.addCriterion("create_time not like", value, "createTime");
            return (RoomExampleBase.Criteria)this;
        }

        public RoomExampleBase.Criteria andCreateTimeIn(List<String> values) {
            this.addCriterion("create_time in", values, "createTime");
            return (RoomExampleBase.Criteria)this;
        }

        public RoomExampleBase.Criteria andCreateTimeNotIn(List<String> values) {
            this.addCriterion("create_time not in", values, "createTime");
            return (RoomExampleBase.Criteria)this;
        }

        public RoomExampleBase.Criteria andCreateTimeBetween(String value1, String value2) {
            this.addCriterion("create_time between", value1, value2, "createTime");
            return (RoomExampleBase.Criteria)this;
        }

        public RoomExampleBase.Criteria andCreateTimeNotBetween(String value1, String value2) {
            this.addCriterion("create_time not between", value1, value2, "createTime");
            return (RoomExampleBase.Criteria)this;
        }

        public RoomExampleBase.Criteria andCreateUserIsNull() {
            this.addCriterion("create_user is null");
            return (RoomExampleBase.Criteria)this;
        }

        public RoomExampleBase.Criteria andCreateUserIsNotNull() {
            this.addCriterion("create_user is not null");
            return (RoomExampleBase.Criteria)this;
        }

        public RoomExampleBase.Criteria andCreateUserEqualTo(String value) {
            this.addCriterion("create_user =", value, "createUser");
            return (RoomExampleBase.Criteria)this;
        }

        public RoomExampleBase.Criteria andCreateUserNotEqualTo(String value) {
            this.addCriterion("create_user <>", value, "createUser");
            return (RoomExampleBase.Criteria)this;
        }

        public RoomExampleBase.Criteria andCreateUserGreaterThan(String value) {
            this.addCriterion("create_user >", value, "createUser");
            return (RoomExampleBase.Criteria)this;
        }

        public RoomExampleBase.Criteria andCreateUserGreaterThanOrEqualTo(String value) {
            this.addCriterion("create_user >=", value, "createUser");
            return (RoomExampleBase.Criteria)this;
        }

        public RoomExampleBase.Criteria andCreateUserLessThan(String value) {
            this.addCriterion("create_user <", value, "createUser");
            return (RoomExampleBase.Criteria)this;
        }

        public RoomExampleBase.Criteria andCreateUserLessThanOrEqualTo(String value) {
            this.addCriterion("create_user <=", value, "createUser");
            return (RoomExampleBase.Criteria)this;
        }

        public RoomExampleBase.Criteria andCreateUserLike(String value) {
            this.addCriterion("create_user like", value, "createUser");
            return (RoomExampleBase.Criteria)this;
        }

        public RoomExampleBase.Criteria andCreateUserNotLike(String value) {
            this.addCriterion("create_user not like", value, "createUser");
            return (RoomExampleBase.Criteria)this;
        }

        public RoomExampleBase.Criteria andCreateUserIn(List<String> values) {
            this.addCriterion("create_user in", values, "createUser");
            return (RoomExampleBase.Criteria)this;
        }

        public RoomExampleBase.Criteria andCreateUserNotIn(List<String> values) {
            this.addCriterion("create_user not in", values, "createUser");
            return (RoomExampleBase.Criteria)this;
        }

        public RoomExampleBase.Criteria andCreateUserBetween(String value1, String value2) {
            this.addCriterion("create_user between", value1, value2, "createUser");
            return (RoomExampleBase.Criteria)this;
        }

        public RoomExampleBase.Criteria andCreateUserNotBetween(String value1, String value2) {
            this.addCriterion("create_user not between", value1, value2, "createUser");
            return (RoomExampleBase.Criteria)this;
        }

        public RoomExampleBase.Criteria andUpdateTimeIsNull() {
            this.addCriterion("update_time is null");
            return (RoomExampleBase.Criteria)this;
        }

        public RoomExampleBase.Criteria andUpdateTimeIsNotNull() {
            this.addCriterion("update_time is not null");
            return (RoomExampleBase.Criteria)this;
        }

        public RoomExampleBase.Criteria andUpdateTimeEqualTo(String value) {
            this.addCriterion("update_time =", value, "updateTime");
            return (RoomExampleBase.Criteria)this;
        }

        public RoomExampleBase.Criteria andUpdateTimeNotEqualTo(String value) {
            this.addCriterion("update_time <>", value, "updateTime");
            return (RoomExampleBase.Criteria)this;
        }

        public RoomExampleBase.Criteria andUpdateTimeGreaterThan(String value) {
            this.addCriterion("update_time >", value, "updateTime");
            return (RoomExampleBase.Criteria)this;
        }

        public RoomExampleBase.Criteria andUpdateTimeGreaterThanOrEqualTo(String value) {
            this.addCriterion("update_time >=", value, "updateTime");
            return (RoomExampleBase.Criteria)this;
        }

        public RoomExampleBase.Criteria andUpdateTimeLessThan(String value) {
            this.addCriterion("update_time <", value, "updateTime");
            return (RoomExampleBase.Criteria)this;
        }

        public RoomExampleBase.Criteria andUpdateTimeLessThanOrEqualTo(String value) {
            this.addCriterion("update_time <=", value, "updateTime");
            return (RoomExampleBase.Criteria)this;
        }

        public RoomExampleBase.Criteria andUpdateTimeLike(String value) {
            this.addCriterion("update_time like", value, "updateTime");
            return (RoomExampleBase.Criteria)this;
        }

        public RoomExampleBase.Criteria andUpdateTimeNotLike(String value) {
            this.addCriterion("update_time not like", value, "updateTime");
            return (RoomExampleBase.Criteria)this;
        }

        public RoomExampleBase.Criteria andUpdateTimeIn(List<String> values) {
            this.addCriterion("update_time in", values, "updateTime");
            return (RoomExampleBase.Criteria)this;
        }

        public RoomExampleBase.Criteria andUpdateTimeNotIn(List<String> values) {
            this.addCriterion("update_time not in", values, "updateTime");
            return (RoomExampleBase.Criteria)this;
        }

        public RoomExampleBase.Criteria andUpdateTimeBetween(String value1, String value2) {
            this.addCriterion("update_time between", value1, value2, "updateTime");
            return (RoomExampleBase.Criteria)this;
        }

        public RoomExampleBase.Criteria andUpdateTimeNotBetween(String value1, String value2) {
            this.addCriterion("update_time not between", value1, value2, "updateTime");
            return (RoomExampleBase.Criteria)this;
        }

        public RoomExampleBase.Criteria andUpdateUserIsNull() {
            this.addCriterion("update_user is null");
            return (RoomExampleBase.Criteria)this;
        }

        public RoomExampleBase.Criteria andUpdateUserIsNotNull() {
            this.addCriterion("update_user is not null");
            return (RoomExampleBase.Criteria)this;
        }

        public RoomExampleBase.Criteria andUpdateUserEqualTo(String value) {
            this.addCriterion("update_user =", value, "updateUser");
            return (RoomExampleBase.Criteria)this;
        }

        public RoomExampleBase.Criteria andUpdateUserNotEqualTo(String value) {
            this.addCriterion("update_user <>", value, "updateUser");
            return (RoomExampleBase.Criteria)this;
        }

        public RoomExampleBase.Criteria andUpdateUserGreaterThan(String value) {
            this.addCriterion("update_user >", value, "updateUser");
            return (RoomExampleBase.Criteria)this;
        }

        public RoomExampleBase.Criteria andUpdateUserGreaterThanOrEqualTo(String value) {
            this.addCriterion("update_user >=", value, "updateUser");
            return (RoomExampleBase.Criteria)this;
        }

        public RoomExampleBase.Criteria andUpdateUserLessThan(String value) {
            this.addCriterion("update_user <", value, "updateUser");
            return (RoomExampleBase.Criteria)this;
        }

        public RoomExampleBase.Criteria andUpdateUserLessThanOrEqualTo(String value) {
            this.addCriterion("update_user <=", value, "updateUser");
            return (RoomExampleBase.Criteria)this;
        }

        public RoomExampleBase.Criteria andUpdateUserLike(String value) {
            this.addCriterion("update_user like", value, "updateUser");
            return (RoomExampleBase.Criteria)this;
        }

        public RoomExampleBase.Criteria andUpdateUserNotLike(String value) {
            this.addCriterion("update_user not like", value, "updateUser");
            return (RoomExampleBase.Criteria)this;
        }

        public RoomExampleBase.Criteria andUpdateUserIn(List<String> values) {
            this.addCriterion("update_user in", values, "updateUser");
            return (RoomExampleBase.Criteria)this;
        }

        public RoomExampleBase.Criteria andUpdateUserNotIn(List<String> values) {
            this.addCriterion("update_user not in", values, "updateUser");
            return (RoomExampleBase.Criteria)this;
        }

        public RoomExampleBase.Criteria andUpdateUserBetween(String value1, String value2) {
            this.addCriterion("update_user between", value1, value2, "updateUser");
            return (RoomExampleBase.Criteria)this;
        }

        public RoomExampleBase.Criteria andUpdateUserNotBetween(String value1, String value2) {
            this.addCriterion("update_user not between", value1, value2, "updateUser");
            return (RoomExampleBase.Criteria)this;
        }
    }
}
